package com.css.fxfzypg.modules.baseData.repository;

import com.css.fxfzypg.modules.baseData.entity.Road;
import com.css.fxfzypg.modules.baseData.queryParams.RoadQueryParams;
import org.springframework.data.domain.Page;

import java.sql.Timestamp;
import java.util.List;

public interface RoadRepository {
    Road updateRoadById(Road road);
    void deleteRoadsById(List<Integer> ids, Timestamp timestamp);
    Road saveRoad(Road road);
    Page<Road> getAllRoadParams(RoadQueryParams queryParams);
    Road getRoadById(Integer id);
    List<Road> getAll();
    void importExcel(List<Road> roads);

    Integer countByCounty(String province, String city, String county);
    Integer countByCity(String province, String city);
    Integer countByProvince(String province);

    Integer countByProvinceAndYear(String provinceName, String taskYear);

    List<Road> getRoadByDistrict(String province, String city, String county);

    boolean getRoadByGeom(String geomText, String taskRegion);

    boolean getRoadByTaskId(String geomText, String taskId);
}
